[dbo].[BAEEventGetAllLinkedFunctions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetAllLinkedFunctions

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(64)	64

SQL Script

CREATE PROCEDURE [dbo].[BAEEventGetAllLinkedFunctions] @eventCode varchar(64) as
SELECT parent.PRODUCT_CODE AS 'PARENT_PRODUCT_CODE', p.*
    FROM Product_Sub ps
    INNER JOIN Product p on p.PRODUCT_CODE = ps.CHILD_PRODUCT_CODE
    INNER JOIN Product parent ON ps.PRODUCT_CODE = parent.PRODUCT_CODE
    WHERE parent.PRODUCT_MAJOR = @eventCode

GO

Uses

[dbo].[Product]
[dbo].[Product_Sub]
dbo